package com.lyq.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lyq.pojo.Doctor;
import com.lyq.pojo.VO.DoctorVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lyq
 * @since 2020-05-08
 */
public interface DoctorMapper extends BaseMapper<Doctor> {
     @Select("SELECT d.*,de.de_zh_name,h.name FROM doctor d,department de,hospital h WHERE d.did = de.id AND d.hid = h.id AND d.deleted=0;")
     List<DoctorVo> SelectDoctorAll();
}
